Exploratory Analysis of table place_text_property¶

Table extract¶

pk_named_place_text_property property_type lang_iso_code text notes fk_named_place creator creation_time modifier modification_time concat_nptp
3254 23750.0 notice fra Chef-lieu du canton au 1er janvier 2009 NaN 88581.0 4.0 2009-11-16 10:05:21.000 4.0 2014-02-06 12:19:14 NPTP23750
17138 37696.0 complment fra Russia NaN 8977.0 3.0 2007-07-20 16:47:45.000 3.0 2014-02-06 12:19:14 NPTP37696
5104 25647.0 complment fra 8226107 NaN 86383.0 4.0 2009-11-16 10:05:11.000 4.0 2014-02-06 12:19:14 NPTP25647
3124 23622.0 notice fra Chef-lieu du canton au 1er janvier 2009 NaN 88453.0 4.0 2009-11-16 10:05:20.000 4.0 2014-02-06 12:19:14 NPTP23622
9856 30401.0 complment fra France NaN 1674.0 3.0 2007-07-20 16:47:45.000 3.0 2014-02-06 12:19:14 NPTP30401

Discovery¶

Columns contain:
Total number of rows: 26549
  - "pk_named_place_text_property":   0.00% empty - 26549 (100.00%) uniques (eg: 41200.0; 20543.0; 20545.0)
  -                "property_type":   0.00% empty -     2 (  0.01%) uniques (eg: notice; complment)
  -                         "text":   0.00% empty -  9221 ( 34.73%) uniques (eg: Saarlouis; Salvador d...; / Capitale...)
  -               "fk_named_place":   0.00% empty - 22432 ( 84.49%) uniques (eg: 121395.0; 59.0; 3697.0)
  -                "creation_time":   0.00% empty -  1570 (  5.91%) uniques (eg: 2014-01-30...; 2007-07-20...; 2009-08-21...)
  -                  "concat_nptp":   0.00% empty - 26549 (100.00%) uniques (eg: NPTP41200; NPTP20543; NPTP20545)
  -                      "creator":   0.00% empty -    42 (  0.16%) uniques (eg: 67.0; 3.0; 4.0)
  -                     "modifier":   0.00% empty -    41 (  0.15%) uniques (eg: 67.0; 3.0; 4.0)
  -                "lang_iso_code":   0.06% empty -     4 (  0.02%) uniques (eg: fra; ita; nan)
  -            "modification_time":   3.94% empty -   218 (  0.82%) uniques (eg: 2014-02-06...; nan; 2017-09-05...)
  -                        "notes":  99.60% empty -    26 (  0.10%) uniques (eg: nan; Sourcehttp...; Source :ht...)

Type parsing¶

Columns analysis¶

Here we will report the analysis of interesting information found on different columns. They are not exhaustive.

property_type¶

text¶

All HTML tags, non ASCII chars and new line are removed.

creation_time¶

creator¶

lang_iso_code¶